UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2KpeIPKp4ir6hsZAUrxZCSEetPEPafTs/gig5yt6gg8='
WHERE
key_id = '7477a42397855ce53d8d630704b13fd3bd1072735ded86da3a8037116cbb3a10'
AND (
token = '2KpeIPKp4ir6hsZAUrxZCSEetPEPafTs/gig5yt6gg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)