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