UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCmJdoF/wxPwscqeyg2PS37wkVZxd2LydyGxm2EkKz4='
WHERE
key_id = '1793cb46e759c54f1a0501ba36891d049b55c2290a028476f0a0d2c585aac64e'
AND (
token = 'bCmJdoF/wxPwscqeyg2PS37wkVZxd2LydyGxm2EkKz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)