UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QRizrjUGsRtRNkJgxtdVxV8Kfyr46uPFDQhuDnFSM7Q='
WHERE
key_id = '709f10e8de8c8cb2f5faf6e7e6e0dd46c49f2b39e6ca1629e3ecfd18f8493b8f'
AND (
token = 'QRizrjUGsRtRNkJgxtdVxV8Kfyr46uPFDQhuDnFSM7Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)