UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Cf6g/nuCWzVDbK7WEaehNTRuuUtvTDx3W716zod5b8='
WHERE
key_id = '06eb88e275abe5e9894383cea167ed916a0b98eb07b04b4eddb8ed903583a376'
AND (
token = '9Cf6g/nuCWzVDbK7WEaehNTRuuUtvTDx3W716zod5b8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)