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