UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nfHG46QrMKGDj/oahG/HhCTytHfIKrAlIXURCinRIf4='
WHERE
key_id = '30bed256a56110a866ab4e4149f076ace1acb1fb3f3ace305cf39ae9427d5a8d'
AND (
token = 'nfHG46QrMKGDj/oahG/HhCTytHfIKrAlIXURCinRIf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)