UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sBDRUykyYIrH5DPy0U20l0Qb7RsrRVxTC6LKxxglJO8='
WHERE
key_id = '149b776d1db0d027ade358e4f52379652a630b0d323c8ce34b0aae106e7311eb'
AND (
token = 'sBDRUykyYIrH5DPy0U20l0Qb7RsrRVxTC6LKxxglJO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)