UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j6sBW5UlZcBDmnmY8DCEsKXLzeoeozEdPHb6EKcwBQc='
WHERE
key_id = 'd3bb6467d1881b892cd59c225ce318f0c29bcfdee50c6cd9ee5d67dc706f19b5'
AND (
token = 'j6sBW5UlZcBDmnmY8DCEsKXLzeoeozEdPHb6EKcwBQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)