UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HFWHW7eo3VJVJg8BTphEdOdvahC8fW3Fk2LebNdW5vI='
WHERE
key_id = '3b9310e352a652013140d78462538da842a70e56b8392e2d7395978a21755317'
AND (
token = 'HFWHW7eo3VJVJg8BTphEdOdvahC8fW3Fk2LebNdW5vI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)