UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QTOTNAstCnTOFc4inplkHaa5vKfbYIA4gtMa0GsAjj8='
WHERE
key_id = 'fecf7fb63c640afb1da703ae98845ba2eef6241220582c497cc1ad9aed5c1667'
AND (
token = 'QTOTNAstCnTOFc4inplkHaa5vKfbYIA4gtMa0GsAjj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)