UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hUdGbb9hW3E1o6IvhzxOebna/ul31iidpZo7jR4hvYY='
WHERE
key_id = 'ca5ba69da472f6271e7eb389df37187800bf25dd18be2ee6356a4276767e0502'
AND (
token = 'hUdGbb9hW3E1o6IvhzxOebna/ul31iidpZo7jR4hvYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)