UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vAPK8ji5P1WrC1eui89plcSeqqyNt1CvjOoMgeICF0='
WHERE
key_id = '0ea547f005c1ecdbfba249e5a22591881530d8a8b6d04d86b1ac3dbdb207e75e'
AND (
token = '6vAPK8ji5P1WrC1eui89plcSeqqyNt1CvjOoMgeICF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)