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