UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q70KcTjqzY9oEds5ZAvez1c1vzqbYhng+IW/u+V9HwY='
WHERE
key_id = '9fe84534e91554c76fa0c0a38d759a5000287638a019d47194a6bf10e1a51ef2'
AND (
token = 'Q70KcTjqzY9oEds5ZAvez1c1vzqbYhng+IW/u+V9HwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)