UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dqROfscRTiAQkH0lvO9rjvG6CYYuhAt/iDudAPTVv1k='
WHERE
key_id = 'a9703e154e3ef9aaee6aaa71af7e7e47d399dfdc2437aceb41321a76286120c3'
AND (
token = 'dqROfscRTiAQkH0lvO9rjvG6CYYuhAt/iDudAPTVv1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)