UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qIYmKzKoegJI+4M2HPGg7RL7lDSjN9YHnGi7wno9nEU='
WHERE
key_id = 'eaf43f1ecf64e51945d989761f111aaed70549fde240efe5a8a581b62edf7e26'
AND (
token = 'qIYmKzKoegJI+4M2HPGg7RL7lDSjN9YHnGi7wno9nEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)