UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZtCuMDxBao7Xz+rYD5D8JkvtXGaeHuNbOWq85ab+iY='
WHERE
key_id = 'c741c9edb3fc8160b182f76f56b28e4955168167e9d413c3a365759c2464f699'
AND (
token = 'zZtCuMDxBao7Xz+rYD5D8JkvtXGaeHuNbOWq85ab+iY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)