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