UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n8+jeG/f1FqHBUChdvo1rNGVjcHyNwjXQKWp20NAD9A='
WHERE
key_id = '8059984222ce9c4a40417eaf1e23e6c07d080eb6c9110e6ac0b616804d836bc2'
AND (
token = 'n8+jeG/f1FqHBUChdvo1rNGVjcHyNwjXQKWp20NAD9A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)