UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1nn2gKNPfoLafkDMevPDOjSVeFIPSGlEmwebls2Rgro='
WHERE
key_id = 'b43f047700354f76c4019076ce4d8e31995d9e4c207af70e18c040ff76473e34'
AND (
token = '1nn2gKNPfoLafkDMevPDOjSVeFIPSGlEmwebls2Rgro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)