UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7cc9XdBqCPjfz6PlsBgqIfxQk0c3bhxess+otV3Hn1E='
WHERE
key_id = '3e8dd27f17f9447db643f5d612880cc0c567783da38750c963c597eab0811d47'
AND (
token = '7cc9XdBqCPjfz6PlsBgqIfxQk0c3bhxess+otV3Hn1E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)