UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KIYIbQ1EwHziZgFwNaCLeC158uGCvxAl1ZfjwBPtGbw='
WHERE
key_id = '7bfe08189e9b779c2fc3988750c17281f222c5b11185c45e6ba8bfd11a0a0fdc'
AND (
token = 'KIYIbQ1EwHziZgFwNaCLeC158uGCvxAl1ZfjwBPtGbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)