UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NTc7KIhv1Yj6elQeytmQ6IVof+7BPVjnxq00Kc6RHh0='
WHERE
key_id = '6176070fafe422d714b13fbe85332199fb8b46a60cf954134720aaf9fd36962e'
AND (
token = 'NTc7KIhv1Yj6elQeytmQ6IVof+7BPVjnxq00Kc6RHh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)