UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't8eLOk3UsapJzC2mkDMfX9MGhCEnOtqHs/SDweUyvrc='
WHERE
key_id = 'c6338b24e5b8d4d11f156736f7653900071b3e0c262e0a390573e03746273910'
AND (
token = 't8eLOk3UsapJzC2mkDMfX9MGhCEnOtqHs/SDweUyvrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)