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